[dbo].[Exhb_Booth

Property	Value
Heap
Row Count	17
Created	3:12:14 PM Friday, January 07, 2011
Last Modified	11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Default
$Indexes iExhb_Booth_HistEXHB_ID: EXHB_ID\MEET_ID\BOOTH_NUMBER$	EXHB_ID	varchar(10)	10	('')
$Indexes iExhb_Booth_HistEXHB_ID: EXHB_ID\MEET_ID\BOOTH_NUMBER$	MEET_ID	varchar(10)	10	('')
	EXHB_DATE	datetime	8
	OLD_DATA	varchar(30)	30
	NEW_DATA	varchar(30)	30
	ITEM	varchar(40)	40
$Indexes iExhb_Booth_HistEXHB_ID: EXHB_ID\MEET_ID\BOOTH_NUMBER$	BOOTH_NUMBER	varchar(20)	20
	COMMENTS	text	max
	TIME_STAMP	timestamp	8

Name	Columns
iExhb_Booth_HistEXHB_ID	EXHB_ID, MEET_ID, BOOTH_NUMBER

Type	Action	Owning Principal
Grant	Delete	IMIS
Grant	Insert	IMIS
Grant	References	IMIS
Grant	Select	IMIS
Grant	Update	IMIS

SQL Script

CREATE TABLE [dbo].[Exhb_Booth_Hist]
(
[EXHB_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Booth_Hist_EXHB_ID] DEFAULT (''),
[MEET_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Booth_Hist_MEET_ID] DEFAULT (''),
[EXHB_DATE] [datetime] NOT NULL,
[OLD_DATA] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NEW_DATA] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ITEM] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BOOTH_NUMBER] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[COMMENTS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iExhb_Booth_HistEXHB_ID] ON [dbo].[Exhb_Booth_Hist] ([EXHB_ID], [MEET_ID], [BOOTH_NUMBER]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Exhb_Booth_Hist] TO [IMIS]
GRANT SELECT ON  [dbo].[Exhb_Booth_Hist] TO [IMIS]
GRANT INSERT ON  [dbo].[Exhb_Booth_Hist] TO [IMIS]
GRANT DELETE ON  [dbo].[Exhb_Booth_Hist] TO [IMIS]
GRANT UPDATE ON  [dbo].[Exhb_Booth_Hist] TO [IMIS]
GO